after some playing, we finally got postgres 7.0.3 running, now on
pg_dump, i get an error:
> ./bin/pg_dumpall > dumped
ERROR: Cannot insert a duplicate key into unique index pg_type_typname_index
ERROR: Relation 'tmp_pg_shadow' does not exist
ERROR: Relation 'tmp_pg_shadow' does not exist
if i try just one database, i get this:
> pg_dump immedia > immediadb
Connection to database 'immedia' failed.
FATAL 1: Database 'immedia', OID 18784, has disappeared from pg_database
but the database is in pg_database.
if i sound a bit lost, it's because i am. up until this point, all i
had to do was install postgres, and somebody else used/maintained it.
>ok, so i've got a pretty bad problem.
>my system go borked last week, and i had to back everything up and reinstall.
>i was running postgresql 7.0.* on openbsd2.8.
>i switched to gentoo 1.2, and it emerged postgresql 7.2.2.
>
>now i've got some old databases on a new system that can't use them.
>my brother tried installing postgresql 7.0.3 on his openbsd 3.1
>system [so i could do what the docs say, pg_dumpall], but can't get
>it started because of some nasty shmget errors.
>specifically:
>IpcMemoryCreate: shmget failed (Permission denied) key=5432010,
>size=144, permission=700
>
>i really need to get these databases back online. is there anything i can do?
>--
>=-=--------------------------------------------=-=
> -.c.-
>
> My mistress when she walks treads on the ground.